/**   
* @Title: IStaticData.java 
* @Package com.csis.system.common 
* @Description: TODO
* @author dailey  
* @date 2012-9-27
* @version V1.0   
*/
package com.csis.system.common;

import java.io.File;

/**
 * @author dailey
 *
 */
public interface IStaticData {
	String SESSION_USER = "user";
	String PATH_XML_MENU_ALL = "menu_all.xml";
	String SESSION_VALDATION = "validation_image";
	String DEFALUT_USER_PASS = "123456";
	String RESOURCE_IMG_PATH = "resource/img";
	String RESOURCE_IMG_DEFAULT_JPG = RESOURCE_IMG_PATH + File.separator + "default.jpg";
	String UPLOAD_IAMGE_FILE = "upload_image";

	Integer ROLE_ADMIN = 5;
	Integer ROLE_MANAGER = 4;
	Integer ROLE_STORER = 3;
	Integer ROLE_BUYER = 2;
	Integer ROLE_SALER = 1;

	public final String ORIGINAL_PASSWORD_MISMATCH = "0";
	public final String NEW_REPEAT_PASSWORD_MISMATCH = "1";
	public final String NEW_ORIGINAL_PASSWORD_SAME = "2";
	public final String NEW_ORIGINAL_REPEAT_PASSWORD_OK = "3";

	String SALE_STATUS_VALID = "有效";
	String SALE_STATUS_INVALID = "无效";

	int SALE_STATUS_VALID_CODE = 1;
	int SALE_STATUS_INVALID_CODE = 0;

	String TABLE_USER = "user";
	String COLUMN_USER_USERID = "user_id";
	String COLUMN_USER_USERNAME = "user_name";
	String COLUMN_USER_USERPASSWORD = "user_password";
	String COLUMN_USER_USERPHONE = "user_phone";
	String COLUMN_USER_USERADDRESS = "user_address";
	String COLUMN_USER_USERNOTE = "user_note";

	String TABLE_ROLE = "role";
	String COLUMN_ROLE_ROLEID = "role_id";
	String COLUMN_ROLE_ROLENAME = "role_name";

	String TABLE_ROLE_USER_MAP = "role_user_map";
	String COLUMN_ROLE_USER_MAP_MAPID = "map_id";
	String COLUMN_ROLE_USER_MAP_ROLEID = "role_id";
	String COLUMN_ROLE_USER_MAP_USERID = "user_id";

	String TABLE_PRODUCT = "product";
	String COLUMN_PRODUCT_PRODUCTID = "product_id";
	String COLUMN_PRODUCT_CATEGORYID = "category_id";
	String COLUMN_PRODUCT_PRODUCTNAME = "product_name";
	String COLUMN_PRODUCT_PRODUCTCATEGORY = "product_category";
	String COLUMN_PRODUCT_PRODUCTCOLOR = "product_color";
	String COLUMN_PRODUCT_PRODUCTSIZE = "product_size";
	String COLUMN_PRODUCT_PRODUCTPRICE1 = "product_price1";
	String COLUMN_PRODUCT_PRODUCTPRICE2 = "product_price2";
	String COLUMN_PRODUCT_PRODUCTPRICE3 = "product_price3";
	String COLUMN_PRODUCT_PRODUCTPRICEUNIT = "product_price_unit";
	String COLUMN_PRODUCT_PRODUCTFACTORY = "product_factory";
	String COLUMN_PRODUCT_PRODUCTUPDATE = "product_update";
	String COLUMN_PRODUCT_PRODUCTIMAGE = "product_image";
	String COLUMN_PRODUCT_PRODUCTNOTE = "product_note";

	String TABLE_CATEGORY = "category";
	String COLUMN_CATEGORY_CATEGORYID = "category_id";
	String COLUMN_CATEGORY_CATEGORYNAME = "category_name";
	String COLUMN_CATEGORY_CATEGORYPARENT = "category_parent";

	String TABLE_WAREHOUSE = "warehouse";
	String COLUMN_WAREHOUSE_WAREID = "ware_id";
	String COLUMN_WAREHOUSE_WARENAME = "ware_name";
	String COLUMN_WAREHOUSE_WARENOTE = "ware_note";

	String TABLE_WARE_USER_MAP = "ware_user_map";
	String COLUMN_WARE_USER_MAP_MAPID = "map_id";
	String COLUMN_WARE_USER_MAP_USERID = "user_id";
	String COLUMN_WARE_USER_MAP_WAREID = "ware_id";

	String TABLE_SALELIST = "salelist";
	String COLUMN_SALELIST_SALENO = "sale_no";
	String COLUMN_SALELIST_CUSTOMERID = "customer_id";
	String COLUMN_SALELIST_SALEDATE = "sale_date";
	String COLUMN_SALELIST_USERID = "user_id";
	String COLUMN_SALELIST_PRODUCTID = "product_id";
	String COLUMN_SALELIST_PRODUCTCOUNT = "product_count";
	String COLUMN_SALELIST_PRODUCTCOLOR = "product_color";
	String COLUMN_SALELIST_PRODUCTSIZE = "product_size";
	String COLUMN_SALELIST_PRODUCTPRICE = "product_price";
	String COLUMN_SALELIST_DISCOUNT = "discount";
	String COLUMN_SALELIST_TOTAL = "total";
	String COLUMN_SALELIST_SALESTATUS = "sale_status";
	String COLUMN_SALELIST_SALENOTE = "sale_note";

	String TABLE_CUSTOMER = "customer";
	String COLUMN_CUSTOMER_CUSTOMERID = "customer_id";
	String COLUMN_CUSTOMER_CUSTOMERNAME = "customer_name";
	String COLUMN_CUSTOMER_CUSTOMERADDRESS = "customer_address";
	String COLUMN_CUSTOMER_CUSTOMERZIP = "customer_zip";
	String COLUMN_CUSTOMER_CUSTOMERACCOUNT = "customer_account";
	String COLUMN_CUSTOMER_CUSTOMERBANK = "customer_bank";
	String COLUMN_CUSTOMER_CUSTOMERCONTACT = "customer_contact";
	String COLUMN_CUSTOMER_CUSTOMERNOTE = "customer_note";

	String TABLE_STOCKLIST = "stocklist";
	String COLUMN_STOCKLIST_STOCKNO = "stock_no";
	String COLUMN_STOCKLIST_USERID = "user_id";
	String COLUMN_STOCKLIST_STOCKDATE = "stock_date";
	String COLUMN_STOCKLIST_SUPPLIERID = "supplier_id";
	String COLUMN_STOCKLIST_PRODUCTID = "product_id";
	String COLUMN_STOCKLIST_PRODUCTCOUNT = "product_count";
	String COLUMN_STOCKLIST_PRODUCTCOLOR = "product_color";
	String COLUMN_STOCKLIST_PRODUCTSIZE = "product_size";
	String COLUMN_STOCKLIST_PRODUCTPRICE = "product_price";
	String COLUMN_STOCKLIST_DISCOUNT = "discount";
	String COLUMN_STOCKLIST_TOTAL = "total";
	String COLUMN_STOCKLIST_STOCKSTATUS = "stock_status";
	String COLUMN_STOCKLIST_STOCKNOTE = "stock_note";

	String TABLE_SUPPLIER = "supplier";
	String COLUMN_SUPPLIER_SUPPLIERID = "supplier_id";
	String COLUMN_SUPPLIER_SUPPLIERNAME = "supplier_name";
	String COLUMN_SUPPLIER_SUPPLIERADDRESS = "supplier_address";
	String COLUMN_SUPPLIER_SUPPLIERZIP = "supplier_zip";
	String COLUMN_SUPPLIER_SUPPLIERACCOUNT = "supplier_account";
	String COLUMN_SUPPLIER_SUPPLIERBANK = "supplier_bank";
	String COLUMN_SUPPLIER_SUPPLIERCONTACT = "supplier_contact";
	String COLUMN_SUPPLIER_SUPPLIERNOTE = "supplier_note";

	String TABLE_ENTRYLIST = "entrylist";
	String COLUMN_ENTRYLIST_ENTRYNO = "entry_no";
	String COLUMN_ENTRYLIST_WAREID = "ware_id";
	String COLUMN_ENTRYLIST_ENTRYDATE = "entry_date";
	String COLUMN_ENTRYLIST_PRODUCTID = "product_id";
	String COLUMN_ENTRYLIST_PRODUCTCOUNT = "product_count";
	String COLUMN_ENTRYLIST_PRODUCTCOLOR = "product_color";
	String COLUMN_ENTRYLIST_PRODUCTSIZE = "product_size";
	String COLUMN_ENTRYLIST_PRODUCTPRICE = "product_price";
	String COLUMN_ENTRYLIST_TOTAL = "total";
	String COLUMN_ENTRYLIST_USERID = "user_id";
	String COLUMN_ENTRYLIST_ENTRYNOTE = "entry_note";

	String TABLE_PICKLIST = "picklist";
	String COLUMN_PICKLIST_PICKNO = "pick_no";
	String COLUMN_PICKLIST_WAREID = "ware_id";
	String COLUMN_PICKLIST_PICKDATE = "pick_date";
	String COLUMN_PICKLIST_USERID = "user_id";
	String COLUMN_PICKLIST_CUSTOMERID = "customer_id";
	String COLUMN_PICKLIST_PRODUCTID = "product_id";
	String COLUMN_PICKLIST_PRODUCTCOUNT = "product_count";
	String COLUMN_PICKLIST_PRODUCTCOLOR = "product_color";
	String COLUMN_PICKLIST_PRODUCTSIZE = "product_size";
	String COLUMN_PICKLIST_PRODUCTPRICE = "product_price";
	String COLUMN_PICKLIST_DISCOUNT = "discount";
	String COLUMN_PICKLIST_TOTAL = "total";
	String COLUMN_PICKLIST_PICKNOTE = "pick_note";

}
